﻿CREATE TABLE [dbo].[MeniuriAlimentare] (
    [IDMeniu]    INT             IDENTITY (1, 1) NOT NULL,
    [Denumire]   VARCHAR (100)   NOT NULL,
    [IDTipMeniu] INT             NOT NULL,
    [Calorii]    DECIMAL (18)    CONSTRAINT [DF_MeniuriAlimentare_Calorii] DEFAULT ((0)) NOT NULL,
    [Pret]       DECIMAL (18, 2) CONSTRAINT [DF_MeniuriAlimentare_Pret] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_MeniuriAlimentare] PRIMARY KEY CLUSTERED ([IDMeniu] ASC),
    CONSTRAINT [FK_MeniuriAlimentare_TipMeniuAlimentar] FOREIGN KEY ([IDTipMeniu]) REFERENCES [dbo].[TipMeniuAlimentar] ([IDTipMeniu])
);

